100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
computer concepts: final exam review Questions and Correct Answers, 2024. £6.24   Add to cart
Quickly navigate to
Preview
  2.  
  3. Computer
  4.  
  5. Computer

Exam (elaborations)

computer concepts: final exam review Questions and Correct Answers, 2024.
 6 views  0 purchase
  • Module
  • Computer
  • Institution
  • Computer

computer concepts: final exam review Questions and Correct Answers, 2024. which tab and button are document properties located for editing? file tab, info button to align currency symbols and decimal points in a column of numbers, you can apply the _____ number format. accounting to apply a ...

[Show more]

Preview 2 out of 6  pages

Document information

  • June 10, 2024
  • 6
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers

Subjects

  • computer concepts final exam review questions and

Written for

  • Computer
All documents for this subject (123)

Seller

avatar-seller
SOLUTIONSCORE

Content preview

computer concepts: final exam review
Questions and Correct Answers, 2024.
which tab and button are document properties located for editing?
file tab, info button
to align currency symbols and decimal points in a column of numbers, you can
apply the _____ number format.
accounting
to apply a cell style, you would use the cell styles command on the ____ tab
home
to combine multiple cells into one combined cell, which of the following do you
use?
merge and center button
to print your worksheet at its actual size, which of the following would you
select?
no scaling
to return cell contents to its default font and style, you can use the ______
command
clear formats
when you underline cell content, you are using _____
font style
which of the following is a built-in formula that helps you perform complex
calculations?
function
your worksheet is too wide to fit on one portrait page, what is the best way to fix
this problem?
change the page orientation to landscape
a predesigned combination of formats, such as font size and color, is called a cell
default
true
the comma style format adds a comma and a dollar sign to a cell value
false
you can start excel using the start button on windows taskbar or a shortcut on
your desktop
true
you can use the DELETE key to clear cell contents
true
a student is given the task of counting the number of nonblank cells in the range
of cells b1 to b20. which of the following formulas should he use to do so?
=COUNTA(B1:B20)
amanda needs to manually calculate an open worksheet. Which of the following
options should she click on in the formulas tab in the calculation group?
calculate now

, sam wants to count the number of cells between B1 and B20 that contain
numbers in them. Which of the following formulas should he use to do so?
=COUNT(B1:B20)
to change a range's conditional formatting from data bars to icon sets, which of
the following can you do?
delete the conditional formatting
what feature inserts a function that totals the cells above or to the left of the
selected cell?
autosum button
when should you use relative cell references?
when you want to enter sequential values in a range of cells
which of the following inserts a function into a cell?
autosum button
which of the following statements is true about COUNT functions?
the COUNT function returns the number of calls in a range that contain numeric data.
to view a worksheet without headers, margins, and rulers, use page layout view
true
when you copy and paste a formula to a new location, the formula's relative
references do not change
true
to enter data in a cell using examples already in your workbook, you can use the
flash fill feature
true
when you run the spell checker in a workbook, excel automatically checks the
spelling in all worksheets at once
false
for which of the following would you use the paste list arrow on the ribbon when
pasting a copied cell?
to paste the value's number formatting only
to change the name of a worksheet, you rename the _______
sheet tab
which of the following is true when you delete a cell?
when you delete a cell using the delete list arrow, you can choose which way to move
adjacent cells.
to move cell contents one space to the right, you can use the increase space
button
false, indent
to see how copied contents will look with both values and number formatting,
you would use paste numbers
true
a students wants to insert a column sparkline in excel. to do this, she can click on
the cell she wants to insert a sparkline, then click insert tab, select the sparkline
type of choice from the sparklines group and then select OK
true
decreasing a cell's indent moves its contents to the right one space.
false

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller SOLUTIONSCORE. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £6.24. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

64438 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now

Start selling
£6.24
  • (0)
  Add to cart