M

Excel 2010

50 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

You are employed as a financial administrator at TestKing.com. You are using Microsoft Office Excel 2010 to create a financial report.
The first worksheet in the financial report contains sales figures for each Sales person for the first quarter of the year. The second worksheet contains sales figures for each Sales person for the second quarter of the year. The third worksheet contains formulas that pull data from the sales figures on the first and second worksheets.
You want to view all three worksheets simultaneously so you can see how the totals on the third worksheet are affected by changes to the figures in the first two worksheets. You currently have the workbook open in Excel.
Which combination of the following steps would enable you to view all three worksheets side-by-side? Choose two.

Choose all the correct options from the given list.

01 / 50

0 Discussions

Trending Exams