No student devices needed. Know more
19 questions
Microsoft OneDrive is included with Microsoft Office 2016 and Office 365?
True
False
What are the advantages of using Microsoft OneDrive?
You can access your files on any Internet-connected device, at any time.
It provides a convenient way to share your files.
It provides a backup solution for your files.
All of these options are correct.
Joshua is looking for a file, and he can't remember where he saved it. Which tool should he use to run a search for it?
File Explorer
The Assistant
OneDrive
What color squiggly line indicates that the entered word is likely misspelled?
Green
Blue
Red
Aqua
Yolanda has finished a document outlining a business proposal. As she reads through it for mistakes, she realizes that she has used the same word over and over. Which tool should she use to search for alternative words?
Dictionary
Thesaurus
Spelling and Grammar
Backstage View
The default save location is always on the Desktop.
True
False
Jen has created a document containing several headers for her small business. She's applied a lot of custom formatting to her first header and would like to be able to quickly apply the same formatting to the rest. What option should she use?
Copy and Paste
Format Painter
Paste
Copy
Where columns and rows intersect in a table, they form a rectangle known as what?
Line
Unit
Block
Cell
If you want to insert multiple rows or columns, you must first select the same number of existing rows or columns that you want to insert.
True
False
Kelly has created a table in Word and is having difficulty resizing a row with the mouse. Which option will allow her to do some precise sizing?
Table Tools > Layout > Cell Size
Table Tools > Layout > Table Size
Table Tools > Design > Table Size
Table Tools > Design > Table Size
Marcus has created a clustered column chart for his data group. However, the chart data looks very similar from column to column, since each amount shown is close to the number 15,000. What is most likely to be causing Marcus' problem, and what is the best way he can fix it without adjusting his data?
There is no way to fix it; he'll have to adjust his data.
His chart is too small; he can resize it to be bigger.
His data points are all close to 15,000; he can adjust the minimum and maximum value displayed on the axis.
His data points are all close to 15,000; he can increase the zoom on his spreadsheet to show more detail.
A template is a previously saved file that has existing data in it. You must remove the old data before you can use the new.
True
False
When you sort information in a column, only data in that column is sorted; adjacent information does not move with the sort.
True
False
Which of the following is NOT a way to insert a new row or column into a spreadsheet?
Right-click the row or column header and select insert.
Right-click the cell and select insert.
Double-click the row or column header.
Use the Insert button in the Cells group of the Home tab.
The SUM function does one of the following.
Calculates the average of the values in the cells
Counts the number of cells that contain numerical values.
Returns the highest value
Adds the values in the cells
Cell references make it easier to copy formulas when you want to reuse the same formula structure. A relative cell reference is one in which the cell remains relative to the cell that contains the formula.
True
False
If you do NOT want the cell reference to change when you move or copy the formula, you use what?
Absolute cell reference
Relative cell reference
Mixed cell reference
Stay in place cell reference
What key should you tap to utilize an absolute cell reference.
F1
F2
F3
F4
Why should you use a chart in Excel?
Simplify data and not make it more complicated.
Because it is easier.
Make it clear for the visually impaired.
Explore all questions with a free account