Font size
WorksheetsEMTECH Office Productivity
Total questions: 10
Worksheet time: 5mins
The (a) view control the look of your entire presentation including colors, fonts, backgrounds,etc.
The (a) include options for adding placeholders for various content types like Title and Footers
Saving a Powerpoint as (a) renders it as Powerpoint theme.
What is the shortcut to creating an ABSOLUTE REFERENCE cell in Excel in Windows or Mac?
(a)
What symbol indicates an ABSOLUTE REFERENCE in Excel?
(a)
Which of the following mail merge terms lists the specific information to be inserted in a mail merge document?
Data source
Mail Merge
Merge Field
Main document
How would you insert a drop down menu in an Excel cell?
Use conditional fomatting
Insert drop down list
Use Data Validation
Use =List
How would you write the Excel formula for ranking cell D5 compared to all values from D1 to D10?
(a)
What sequence of options would you key in if you want to automatically highlight cells with values lower than 88?
Highlight Cell Rules, Conditional Formatting, Less Than
Conditional Formatting, Highlight Cell Rules, Less Than
Highlight Cell Rules, Between Conditional Formatting
Styles, Highlight Cell Rules, Conditional Formatting, Less Than
What series of options would you click to protect an Excel sheet?
Protect, Protect Sheet
Data, Protect, Protect Sheet
View, Data, Protect Sheet
Review, Protect Sheet
