WorksheetsComputer App - Excel Review
Total questions: 24
Worksheet time: 15mins
By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.
True
False
The fill handle only allows you to copy formulas to one cell below the original formula's cell.
True
False
Luisa is creating a worksheet tracking her company's spending on a project. However, when viewing her document, she has noticed some of the cells contain pound signs/hashtags (as shown in the image). Which of the following suggestions would help Luisa?
Make the cell wider
Change the font format in the cell
Change the number formatting in the cell
Delete the data and retype it
What is an advantage, if any, to using cell references instead of just typing in values?
It will automatically create a sparkline in the next cell
If the cell is changed, the formula will automatically update
It will allow you to format your spreadsheet more quickly
There is no advantage
Petra placed all of her grades from science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is a quick way for her to do this?
Page Layout
Quick Format
Auto-fit
Conditional Formatting
Juan is the director of a summer camp. This spreadsheet contains campers' names, information, and their counselors. Which 2 features will help him sort the list by counselor, then print a list containing only the campers' and counselors' names?
Sort and Track Changes
Custom Sorting and Formatting
Format and Hide Columns
Custom Sorting and Hide Columns
Alex needs to add 3 cells then divide the sum by 4. Which of the following is an example of the correct formula to do this?
=(A1+A2+A3)/4
=A1+A2+A3^4
A1+A2+A3/4
(A1+A2)+A3/4
Mindy wants to find the average of all of her grades, but cannot get the function to work. Her spreadsheet is shown above. What error is Mindy making?
She has the incorrect argument
She is missing an equal sign at the beginning of her formula
She has the wrong function name
The colon (:) should be replaced with a dash (-)
When creating a table in Excel, what will clicking the drop-down arrows in the headings allow you to do?
Fill the columns with color
Format the cells
Filter the data
Hide the column
Which of the following is NOT a type of chart that can be inserted in Excel?
Pie
Doughnut
Circle
2-D Bar
What function would you use to find the highest number in a data series?
MAX
MIN
AVERAGE
SUM
Which of the following would be a correct formula to find the average of cells A1 through A10?
AVERAGE(A1:A10)
=AVERAGE(A1-A10)
=AVERAGE(A1:A10)
=AVERAGE(A1, A10)
What is the shortcut to 'Show Formulas'?
Ctrl + `
Ctrl + S
Ctrl + F
Ctrl + #
Which tool do you use to combine and center contents of multiple cells into one larger cell?
Wrap Text
Merge and Center
Format Painter
Center Alignment
Columns go __________ and are labeled with __________.
Up and down; letters
Up and down; numbers
Across; letters
Across; numbers
Rows go __________ and are labeled with __________.
Up and down; letters
Up and down; numbers
Across; letters
Across; numbers
What kind of software is Excel?
Word processing
Spreadsheet
Database
Presentation
You can place a chart on a separate sheet.
True
False
A spreadsheet has some values entered. Cell A1 contains 10, cell A2 contains 14, cell A3 contains 7. You enter in cell A5 the following "=A1+A2". Which value will be displayed in A5?
10
12
17
24
Which tab do you choose to add pictures and shapes to your spreadsheet?
Home
Insert
Page Layout
Formulas
Which tab do you choose to change the Print Area?
Home
Page Layout
View
Review
What does the Format Painter do?
Copies one cell's contents to the next
Copies one cell's formatting to the next
Changes the formatting of your entire spreadsheet
Changes the font size and style of your text
When entering a formula or function into a cell, which character must you start with?
(
)
+
=
What can you use to move throughout a document?
Tab key
Arrow keys
Enter key
All of these
