NEW
Font size
WorksheetsSpreadsheets Quiz
Total questions: 24
Worksheet time: 18mins
An Excel spreadsheet is a grid made up of:
Lines and Arrows
Points and Arrays
Rows and Columns
Presentation Slides
The boxes formed by the grid of an Excel spreadsheet are called:
Text Boxes
Blanks
Hives
Cells
Which is an example of the name of a cell in a spreadsheet?
B7
1E
43
EE
Google has a product similar to Microsoft Office Excel. What is the name of that product?
Google Docs
Google Drive
Google Slides
Google Sheets
In an Excel spreadsheet, a COLUMN is a(n):
horizontal and designated by a number
vertical and designated by a number
vertical and designated by a letter
area where columns and rows intersect
In the following image, which letter represents the ACTIVE CELL?
A
B
C
D
In this image, which letter represents the ROW HEADING?
A
C
E
F
In the image below, which letter represents the COLUMN HEADING?
A
C
D
E
In the following image, which letter represents GRAPHS or CHARTS?
D
F
G
H
In the following image, which button would you press to change the format of a number to a fraction?
A
B
C
D
In which spreadsheet is the third row selected?
Option 1
Option 2
Option 3
Option 4
Four cells (B2, B3, C2, and C3) are right next to each other. How can you select just the four of them?
Click on columns B and C
Click in the middle of the 4 cells
Click on rows 2 and 3
Click on one and drag over the others
Which command always gets rid of JUST THE TEXT in a selected row or column?
Option 1
Option 2
Option 3
Option 4
Which picture shows the title in TWO merged cells?
Option 1
Option 2
Option 3
Option 4
What is true about text in a cell with right alignment?
It is against the right side.
It is spelled right.
It is straight up and down.
It is in the middle.
How could you make the title on a spreadsheet stand out?
Put borders around all the cells on the spreadsheet.
Choose an unusual font color for the spreadsheet.
Use different formats for different parts of the spreadsheet.
Make all of the fonts on the spreadsheet really big.
What do you click to put a selected column in alphabetical order?
Option 1
Option 2
Option 3
Option 4
Column A's label looks cut off from column B's label. How can you fix the problem.
Merge the cells that have the labels for the two columns.
Make the font for column A's label darker.
Click between the column names and drag until you see the whole label.
Add cell borders.
You typed a long list in a spreadsheet but forgot to put in the third item. How can you quickly fix the list?
Insert a new row after the second row.
Align the text to the middle.
Delete the text and start over.
Copy and paste the list into a different column.
What spreadsheet tool could be used to add together the numbers in a selected group of cells?
Sum
Merge
Sort
Hyperlink
When using formulas in a spreadsheet, which of these operations happens first?
Option 1
Option 2
Option 3
Option 4
Which of these would find the average of cells A1 through A6 if it were typed into the formula bar for another cell?
Option 1
Option 2
Option 3
Option 4
Which answer is a good reason to save a spreadsheet to the cloud?
To publish the data directly to the Internet.
To find specific data quickly and easily.
To allow others to enter data and make changes in the spreadsheet.
To sort your data in descending or ascending order.
Which symbol is needed to use functions and formulas in a spreadsheet software?
Option 1
Option 2
Option 3
Option 4
