Slides (30)
1 -
Jericho wants to import the data from one of his sheets to the newly created sheet. Howwould he do this?
1. =ImportRange(“SpreadsheetKey: Sheet!Range”)
2. =ImportRange(“SpreadsheetKey: SheetRange”)
3. =ImportRange(“SpreadsheetKey”, Sheet:Range”)
4. =ImportRange (“SpreadsheetKey”, ”Sheet!Range”)
2 -
Justine wants to add a new sheet. Where can she find the option to do this?
1. Tools ►New Sheet
2. Insert ►New Sheet
3. File►New Sheet
4. Add►New Sheet
3 -
Wendell wants to add a validation to his data. Where can he find the option to do this?
1. Insert ►Validation
2. Tools ►Data Validation
3. Format ►Data Validation
4. Data►Validation
4 -
Kristine wants to add a list of items as her criteria for validating data input. How should she input them in the criteria box?
1. Apple-Banana-Orange-Pineapple
2. Apple,Banana,Orange,Pineapple
3. Apple;Banana;Orange;Pineapple
4. “Apple””Banana””Orange””Pineapple”
5 -
Marie doesn’t want Google Spreadsheet to accept the input if the data to be entered is incorrect. What option in data validation should she choose?
1. Reject Input
2. Show Warning
3. Disregard Input
4. Cancel Input
6 -
Anica wants to use the keyboard shortcut for changing font style to Bold. What keys should she press?
1. Ctrl+Alt+B
2. Shift+B
3. Ctrl+B
4. Alt+B
7 -
Carlo wants to create new sheet and navigate fromone sheet to another. What buttons should he use?
1. Navigation Buttons
2. Sheet Navigation Buttons
3. Arrow Buttons
4. Tab Buttons
8 -
Verniece wants to automatically input the dates. What function should she use in order to do this?
1. Copy and Paste
2. Auto-fill
3. Wrap Text
4. Freeze Pane
9 -
How can you add multiple rows or columns in a spreadsheet?
1. By selecting only one row or column and clicking "Insert"
2. By selecting the same number of rows or columns you wish to add
3. By right-clicking anywhere and choosing "Insert row"
4. By clicking "Merge" in the toolbar
10 -
Hennessy wants to change the color cell B7. She would have to click the drop-down arrow beside what icon?
1. Paint Brush icon
2. Pencil icon
3. Paint Bucket icon
4. Cell Color icon
11 -
What is the size range (in pixels) allowed for rows and columns in a spreadsheet?
1. 0 to 500
2. 0 to 255
3. 1 to 1000
4. 1 to 2000
12 -
What happens to the mouse pointer when you click and drag rows or columns?
1. It stays the same
2. It changes to a hand
3. It changes to an arrow
4. It changes to a crosshair
13 -
How can you change the currency format of a number in a spreadsheet?
1. Use the Formula bar to add a currency symbol
2. Go to File ►Settings
3. Click on Insert ►Currency Symbol
4. Go to Format ►Number
14 -
Jason wants to enter new data on the right side of his current cell. In order to move to the right, which key should he press?
1. Shift
2. Tab
3. Enter
4. Backspace
15 -
Jennifer is done entering her savings for the day. She closed the spreadsheet without saving because she knew that it would automatically save. Is this true for cloud-based spreadsheets like Google Sheets?
1. No
2. Only if autosave is turned on
3. Yes
4. Only if the file has been saved before
16 -
Ravi wants to enter his new data one cell to the right of his current cell. What key should he press?
1. Up Arrow
2. Tab
3. Shift
4. Enter
17 -
Almira wants to enter new data in the cell above her current cell. Which key should she press?
1. Enter
2. Shift + Enter
3. Tab
4. Spacebar
18 -
What is the easiest way to adjust the size of a column?
1. Use the "Wrap Text" option
2. Double-click on the right border of the cell you want to adjust
3. Drag the right border of the column manually
4. Right-click and choose "Resize column"
19 -
Randy auto-fills his work using the fill handle. What does the fill handle do?
1. Copies data in selected cells
2. Deletes selected data
3. Highlights cells
4. Moves data to a new sheet
20 -
Henry used auto-fill to enter the same data in a single row. What does auto-fill usually do?
1. Randomly inserts numbers
2. Duplicates data without pattern
3. Only works for numerical values
4. Follows a pattern to fill data
21 -
Patricia wants to enter new data in the cell below her current cell. Which key should she press?
1. Arrow key
2. Esc
3. Tab
4. Shift
22 -
Vance used auto-fill horizontally, vertically, and diagonally in all of his data. Which directions does auto-fill actually work in?
1. Horizontally and vertically
2. In any random pattern
3. Only horizontally
4. Vertically and diagonally
23 -
Auto-fill data while typing is available, so Fionna used it to make entering dates and numbers easier. What feature actually helps with this?
1. Conditional Formatting
2. AutoComplete
3. AutoSave
4. Smart Fill
24 -
Kris entered the new name of his spreadsheet using the drop-down menu. How can a spreadsheet name actually be changed?
1. By using a drop-down menu
2. By clicking on the file name
3. By right-clicking on a cell
4. By pressing Ctrl + R
25 -
Yuri wasn’t able to rename her spreadsheet, and when she saw it in her Google Drive, it was labeled as “Untitled Spreadsheet.” Why did this happen?
1. The file was saved incorrectly
2. Google Sheets automatically assigns this name
3. The spreadsheet was deleted
4. The spreadsheet was created from a template
26 -
From the choices below, select the correct Column chart.
1.
2.
3.
4.
27 -
From the choices below, select the correct Bar chart.
1.
2.
3.
4.
28 -
From the choices below, select the correct Line chart.
1.
2.
3.
4.
29 -
From the choices below, select the correct Trend chart.
1.
2.
3.
4.
30 -
Similar Templates
Frequently Asked Questions
How do I access the AhaSlides template library?
You can access templates from the Templates tab in your dashboard after logging in, from the Templates section on our website, or directly in the Editor app.
What are the templates designed for?
Official templates help you prepare interactive presentations for training, meetings, classes, and workshops. Community templates are created by users and shared to inspire others.
How do I host a session using a template?
Select a template, customize it by editing slides, themes, multimedia, and settings, then host it just like any other presentation.
Do I need to pay to use templates?
All templates are free to download and host, but some may exceed the free plan limits (5 quiz questions or 3 polls), which require a paid plan.
If I publish a template to share with my team, will it be visible to all other users?
Yes. Published templates are added to the public library and visible to all users. To keep a template private, share it with team members as collaborators instead.