CWSP PD Pre-Assessment

1

Salvador, Niya, and Empress all work for the same company. Their boss sent an email to the group asking for somebody to handle a specific task for him. She did not specify the task, but rather said there would be more information to follow. Niya quickly volunteered her services not knowing what she was getting herself into; however, she was eager to learn. Niya was not showing good initiative.

1

Oh no! Monica just hit the “start” button to make 30 copies of 20 pages each when her
supervisor runs up with a page for the original document that he forgot to give her. Copies are already coming out of the machine wrong. Look at the photocopier control panel above. Which button should Monica press next? (Click onthe image to enlarge)

10

1

Your supervisor at work doesn't have much for you to do today. He sends you to the finance team on the 35th floor to help prepare 12 copies of annual reports for today's conference. The original annual report is fifteen pages long with information on both sides of each page. Deana, the person who you are helping, has asked that all 12 copies you make come out of the copy machine "double sided." Which setting should you choose before changing the quantity to 12 and pressing start?
(click on the image to enlarge)

1

What is the title of the Excel workbook shown here? (click to enlarge image)

1

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

1

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

1

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

1

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

1

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

1

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

7

The image to the left shows 7 office machines. Each machine is numbered. Drag to match each number with the name of the office machine shown in the image.

1

What formula would you type into cell D4 to calculate Sue's total after weeks 1 and 2?

1

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

1

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

1

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

1

Brandon was at his work study job. He completed well a long and complicated task that his manager provided to him. His manager was busy when Brandon finished. He took out his phone and Snapchat videos to his friend Toya until his manager was ready to give him more work, which he then did eagerly and well for the rest of the day. Brandon did not show good initiative.

3

It's 2:00pm and you have finised all the work Rita gave you. You go ask her what she'd like you to work on next, but she's in a meeting until 3. You are supposed to stay at the office until 4:15 What do you do? (answer should be at least 2 complete sentences with no grammatical or spelling mistakes)

1

Which rows are hidden in the Excel spreadsheet below? (click on image to enlarge)

1

Your supervisor at work has given you a spreadsheet with accounts and their account numbers. Please reorder the accounts in numerical order. (Note: this does not use terminal digit filing)

1

Julio's supervisor has asked him to make copies of a report for today's meeting. He inserts the report into the copy machine, chooses the following options, and presses "Start." How many copies will be made bases on the settings he chose?

1

What is the facilities cost of hosting the job fair in Kissimee?

1

Retype the text EXACTLY as it is found in cell A9

12

Your supervisor has given you a stack of 12 file folders with the following names written on them. These folders are to be put into the filing cabinet in alphabetical order so that it's easier to put paperwork away later, like how much money your company needs to pay each of these people! Please put the following names in correct alphabetical order below.

1

What is the name of the Microsoft Office application represented by this icon?

1

What is the name of the Microsoft Office application represented by this icon?

1

What is the name of the Microsoft Office application represented by this icon?

3

Please put the following files in alphabetical order

1

Which of the icons in the Home ribbon (found inside the red box) can be used to change the text in cell F to be formatted as 3 lines fill the cell instead of flowing over into cells G & H?

Another way of asking the same question is: which icon can be used to make cell F match cell D?

1

When alphabatizing personal names, last name comes first. (Ex. James, LeBron)

1

What is the title of the Excel workbook shown here? (click to enlarge image)

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

The image to the left shows 7 office machines. Each machine is numbered. Drag to match each number with the name of the office machine shown in the image.

What formula would you type into cell D4 to calculate Sue's total after weeks 1 and 2?

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

The detailed list of company expenses is on which page number of the report?

How often does the Exectutive Staff meet?

Who is Rita's boss?

Rita asks you to deliver the report to the other members of the Executive Staff. Three of their assistants are out to lunch. What do you do with those three copies of the report? (choose ONE that is the BEST answer)

When you are in the copy room making copies, the machine runs out of paper after the fifth copy of the report. What do you do? (choose ONE that is the BEST answer)

When you have finished making and delivering all the photocopies, what do you do? (choose ONE that is the BEST answer)

It's 2:00pm and you have finised all the work Rita gave you. You go ask her what she'd like you to work on next, but she's in a meeting until 3. You are supposed to stay at the office until 4:15 What do you do? (answer should be at least 2 complete sentences with no grammatical or spelling mistakes)

Which rows are hidden in the Excel spreadsheet below? (click on image to enlarge)

Your supervisor at work has given you a spreadsheet with accounts and their account numbers. Please reorder the accounts in numerical order. (Note: this does not use terminal digit filing)

Julio's supervisor has asked him to make copies of a report for today's meeting. He inserts the report into the copy machine, chooses the following options, and presses "Start." How many copies will be made bases on the settings he chose?

What is the facilities cost of hosting the job fair in Kissimee?

Retype the text EXACTLY as it is found in cell A9

What is the name of the Microsoft Office application represented by this icon?

What is the name of the Microsoft Office application represented by this icon?

What is the name of the Microsoft Office application represented by this icon?

Please put the following files in alphabetical order

Which of the icons in the Home ribbon (found inside the red box) can be used to change the text in cell F to be formatted as 3 lines fill the cell instead of flowing over into cells G & H?

Another way of asking the same question is: which icon can be used to make cell F match cell D?

When alphabatizing personal names, last name comes first. (Ex. James, LeBron)

What is the sum of all the cells in row 31?

CWSP PD Pre-Assessment

What is the title of the Excel workbook shown here? (click to enlarge image)

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

Your account manager has asked you to type this account name into an Excel spreadsheet. Pay attention to detail and type the account name exactly as it is shown.

The image to the left shows 7 office machines. Each machine is numbered. Drag to match each number with the name of the office machine shown in the image.

What formula would you type into cell D4 to calculate Sue's total after weeks 1 and 2?

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

You are working in Microsoft Word and have highlighted the text you want to alter. What would happen to the text if you clicked the button indicated?

The detailed list of company expenses is on which page number of the report?

How often does the Exectutive Staff meet?

Who is Rita's boss?

Rita asks you to deliver the report to the other members of the Executive Staff. Three of their assistants are out to lunch. What do you do with those three copies of the report? (choose ONE that is the BEST answer)

When you are in the copy room making copies, the machine runs out of paper after the fifth copy of the report. What do you do? (choose ONE that is the BEST answer)

When you have finished making and delivering all the photocopies, what do you do? (choose ONE that is the BEST answer)

Which rows are hidden in the Excel spreadsheet below? (click on image to enlarge)

Your supervisor at work has given you a spreadsheet with accounts and their account numbers. Please reorder the accounts in numerical order. (Note: this does not use terminal digit filing)

Julio's supervisor has asked him to make copies of a report for today's meeting. He inserts the report into the copy machine, chooses the following options, and presses "Start." How many copies will be made bases on the settings he chose?

What is the facilities cost of hosting the job fair in Kissimee?

Retype the text EXACTLY as it is found in cell A9

What is the name of the Microsoft Office application represented by this icon?

What is the name of the Microsoft Office application represented by this icon?

What is the name of the Microsoft Office application represented by this icon?

Please put the following files in alphabetical order

Which of the icons in the Home ribbon (found inside the red box) can be used to change the text in cell F to be formatted as 3 lines fill the cell instead of flowing over into cells G & H? Another way of asking the same question is: which icon can be used to make cell F match cell D?

When alphabatizing personal names, last name comes first. (Ex. James, LeBron)

What is the sum of all the cells in row 31?

Which of the icons in the Home ribbon (found inside the red box) can be used to change the text in cell F to be formatted as 3 lines fill the cell instead of flowing over into cells G & H?

Another way of asking the same question is: which icon can be used to make cell F match cell D?