WorksheetsMicrosoft Excel Review Part 3
Total questions: 21
Worksheet time: 40mins
Identify this icon
Use this icon to quickly add a new worksheet.
Use this icon to insert symbols that are not on your keyboard.
To specify that someone must sign the worksheet, use this function.
Use this icon to insert a circle or square.
Identify this icon
Use this icon to quickly add a new worksheet.
Use this icon to insert symbols that are not on your keyboard.
To specify that someone must sign the worksheet, use this function.
Use this icon to insert a circle or square.
Identify this icon.
Use this icon to quickly add a new worksheet.
Use this icon to insert symbols that are not on your keyboard.
To specify that someone must sign the worksheet, use this function.
Use this icon to insert a circle or square.
Identify this icon.
Use this icon to quickly add a new worksheet.
Use this icon to insert symbols that are not on your keyboard.
To specify that someone must sign the worksheet, use this function.
Use this icon to insert a circle or square.
What should be used to add a process chart or an organizational chart to a worksheet?
Signature Line
WordArt
SmartArt
Shapes
Which of the following can be done to a worksheet?
Name
Rename
Move
All of these
Inserting a hyperlink allows you to create a link in your worksheet for quick access to webpages and files.
TRUE
FALSE
Identify this icon.
Use this icon to insert a column chart.
Use this icon to insert a chart that compares values across geographical regions.
Use this icon to insert a line chart.
Use this icon to insert a pie chart.
Identify this icon.
Use this icon to insert a column chart.
Use this icon to insert a chart that compares values acrossgeographical regions.
Use this icon to insert a line chart.
Use this icon to insert a pie chart.
Identify this icon.
Use this icon to insert a column chart.
Use this icon to insert a chart that compares values acrossgeographical regions.
Use this icon to insert a line chart.
Use this icon to insert a pie chart.
Identify this icon.
Use this icon to insert a column chart.
Use this icon to insert a chart that compares values acrossgeographical regions.
Use this icon to insert a line chart.
Use this icon to insert a pie chart.
Which chart would be best to use to show proportions of a whole?
Column chart
Pie chart
Bar chart
Line chart
Which chart would be best to use to show trends over time?
Column chart
Pie chart
Bar chart
Line chart
Which chart would be best to use to compare values across multiple categories?
Column chart
Pie chart
Bar chart
Line chart
To enter numbers as text, start by keying an apostrophe (‘) at the start of numbers.
TRUE
FALSE
Emily is working on a spreadsheet in her computer. She notices that the cells formatted as labels are not aligned as she wants. What is the default justification for these cells?
right aligned
left aligned
center
1 inch
In Excel, which function would you use to find the lowest number in a range of cells?
MIN
MAX
AVERAGE
SUM
Which Excel function is used to add together the values in a specified range of cells?
COUNT
SUM
DIVIDE
MIN
Emily is working on a project which requires her to organize data across multiple pages. What is the name of the file she would use that contains one or more spreadsheets?
spreadsheet
workbook
cell
cell range
These are vertical and run from top to bottom in a worksheet
Cell
Row
Column
These are horizontal and run from left to right in a worksheet.
Row
Column
Cell
