GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

Ohne Titel

Juan Lupian 10 Fragen

Quiz starten

Fragen in diesem Quiz (10)

  1. 1Which step is not part of planning a worksheet design?
    1. ADecide what input values are needed.
    2. BState the purpose of the worksheet.
    3. CDecide what outputs are needed to achieve the purpose.
    4. DEnter labels, values, and formulas.
  2. 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?
    1. AFormulas
    2. BKeep Source Formatting
    3. CValues & Source Formatting
    4. DValues & Number Formatting
  3. 3Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
    1. AB1*B2
    2. BB2+B3
    3. CB3/B4
    4. DB4^2
  4. 4How can you display formulas within the cells instead of the cell results?
    1. APress Crtl+G
    2. BPress Crtl+`.
    3. CClick Cell Reference on the Home tab.
    4. DPress Crtl+C.
  5. 5What is a fast way to apply serval formats at one time?
    1. AClick each one individually.
    2. BApply a cell style.
    3. CUse AutoFill.
    4. DUse Copy and Paste options.
  6. 6Which of the following is not an alignment option?
    1. AIncrease Indent
    2. BMerge & Center
    3. CFill Color
    4. DWrap Text
  7. 7Which of the following characteristics is not applicable to the Accounting Number Format?
    1. ADollar sign immediately on the left side of the value.
    2. BCommas to separate thousands
    3. CTwo decimal places
    4. DZero values displayed at hyphens
  8. 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?
    1. AClick Paste on the Clipboard group on the Home tab.
    2. BClick the Paste arrow in the Clipboard group and select formulas.
    3. CClick the Paste arrow in the Clipboard group and select Values & Source Formatting.
    4. DDisplay the Paste Special dialog box and select Formulas & Number Formatting.
  9. 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.
    1. ADecrease the Scale value.
    2. BIncrease the left and right margins.
    3. CDecrease column widths if possible.
    4. DSelect a smaller range as the print area.
  10. 10What should you do if you see pound signs (###) instead of values of formulas?
    1. AIncrease the zoom percentage.
    2. BDelete the column.
    3. CAdjust the row height.
    4. DIncrease the column width.

Informationen

Beschreibung
Quiz am Ohne Titel, erstellt von Juan Lupian am 25/09/2017.
Sprache
English
Aufrufe
2
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck