Basic Office Skills

Welcome to the BPS Basic Office Skills exam.  The test consists of 20 multiple choice questions.  There is a 10 minute time limit.

Name
Email
What is the shortcut key to insert a page break in MS Word?

What is the keyboard shortcut for copying selected text in MS Word?

What is the shortcut key to undo the last action in MS Word?

How do you change the margins of a document in MS Word?

Which of these are placed at the end of a document?

Which of the following can you perform using the ruler (select all that apply)?

Which feature would you use to combine a list of names and addresses with a preformatted document or template?

How can you zoom in and out of a Word document (select all that apply)?

How do you edit the header in a Word document?

How do you insert a chart into Word?

What is the purpose of the IF function in Excel?

Which of the following is an absolute reference to cell A5?

What is a Relative Reference in Excel?

How can you reference data across worksheets in Excel?

How can you format a date in Excel (select all that apply)?

How can you hide columns or rows in Excel (select all that apply)?

How can you copy a worksheet in Excel (select all that apply)?

What is the purpose of filtering data in Excel?

What is the purpose of freezing columns or rows in Excel?

How can you create a comment in Excel?

Thank you.  Your submission has been received and will be reviewed shortly.

Posted in .