Quiz
Sem título
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (10)
1Which step is not part of planning a worksheet design?
- ADecide what input values are needed.
- BState the purpose of the worksheet.
- CDecide what outputs are needed to achieve the purpose.
- DEnter labels, values, and formulas.
2You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select?
- AFormulas
- BKeep Source Formatting
- CValues & Source Formatting
- DValues & Number Formatting
3Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
- AB1*B2
- BB2+B3
- CB3/B4
- DB4^2
4How can you display formulas within the cells instead of the cell results?
- APress Crtl+G
- BPress Crtl+`.
- CClick Cell Reference on the Home tab.
- DPress Crtl+C.
5What is a fast way to apply serval formats at one time?
- AClick each one individually.
- BApply a cell style.
- CUse AutoFill.
- DUse Copy and Paste options.
6Which of the following is not an alignment option?
- AIncrease Indent
- BMerge & Center
- CFill Color
- DWrap Text
7Which of the following characteristics is not applicable to the Accounting Number Format?
- ADollar sign immediately on the left side of the value.
- BCommas to separate thousands
- CTwo decimal places
- DZero values displayed at hyphens
8You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than the formulas. What do you do?
- AClick Paste on the Clipboard group on the Home tab.
- BClick the Paste arrow in the Clipboard group and select formulas.
- CClick the Paste arrow in the Clipboard group and select Values & Source Formatting.
- DDisplay the Paste Special dialog box and select Formulas & Number Formatting.
9Assume that data on a consume a whole pointed page and a couple of columns on a second page. You can do all of the following expect what to force the data to print all on one page.
- ADecrease the Scale value.
- BIncrease the left and right margins.
- CDecrease column widths if possible.
- DSelect a smaller range as the print area.
10What should you do if you see pound signs (###) instead of values of formulas?
- AIncrease the zoom percentage.
- BDelete the column.
- CAdjust the row height.
- DIncrease the column width.
Informações
- Descrição
- Quiz sobre Sem título, criado por Juan Lupian em 25-09-2017.
- Autor
- Juan Lupian
- Idioma
- English
- Visualizações
- 2
- Avaliação
- Ainda sem avaliações Avalie este quiz