Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Computer Science Excel Study Guide (Latest Update 2024), Exams of Nursing

Harvard UniversityNursing

Step-by-step instructions on how to perform various tasks in Microsoft Excel, such as centering cell contents, applying cell styles, formatting cells, creating charts, and using functions. The guide also includes tips on how to use conditional formatting, borders, and headers. useful for students and professionals who want to improve their Excel skills.

Typology: Exams

2023/2024

Available from 02/08/2024

MacLarenn
MacLarenn ๐Ÿ‡บ๐Ÿ‡ธ

4

(10)

3.6K documents

1 / 18

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Computer Science Excel Study Guide
(Latest Update 2024)
center the contents of a cell horizontally - Correct Answer
โœ…1. click on cell
2. click on center horizontal button on home screen in second
row
apply the bad style to a cell - Correct Answer โœ…1. click on
the cell
2. click on cell styles
3. chose bad style
Apply the Accounting number format, using the dollar sign ($)
and two decimal places, to a cell range (ex: C4:C15) -
Correct Answer โœ…1. highlight cells
2. right click on cells
3. click on format cells
4. click on number, then choose accounting.
5. make sure to choose 2 decimal places and dollar sign
apply the comma style number format to a cell range (ex:
C4:C15) - Correct Answer โœ…1. highlight cell range
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12

Partial preview of the text

Download Computer Science Excel Study Guide (Latest Update 2024) and more Exams Nursing in PDF only on Docsity!

(Latest Update 2024)

center the contents of a cell horizontally - Correct Answer โœ…1. click on cell

  1. click on center horizontal button on home screen in second row apply the bad style to a cell - Correct Answer โœ…1. click on the cell
  2. click on cell styles
  3. chose bad style Apply the Accounting number format, using the dollar sign ($) and two decimal places, to a cell range (ex: C4:C15) - Correct Answer โœ…1. highlight cells
  4. right click on cells
  5. click on format cells
  6. click on number, then choose accounting.
  7. make sure to choose 2 decimal places and dollar sign apply the comma style number format to a cell range (ex: C4:C15) - Correct Answer โœ…1. highlight cell range

(Latest Update 2024)

  1. click on number (in home page)
  2. choose the comma button bold a cell - Correct Answer โœ…1. click on cell
  3. click on the dark B (bold button) under the font format column (ex: d) using auto fit so that all cell content is visible - Correct Answer โœ…1. click on column
  4. double click on column line change the color of the font in a cell (ex: D9) to blue (standard colors section, column 8) - Correct Answer โœ…1. click on cell
  5. go into home and click the letter with the underlined color
  6. choose the desired color change the font of a cell to cambria - Correct Answer โœ…1. click on the cell
  7. click on the font style button arrow and change to desired font

(Latest Update 2024)

in a cell, enter a formula using the SUM function to total the values in a cell range (B4:B15) - Correct Answer โœ…1. click on a cell

  1. type in the equal sign (=)
  2. type in SUM(
  3. highlight cell range
  4. hit enter merge and center the contents of cell range (ex: A2:D2) - Correct Answer โœ…1. highlight cell range
  5. click on merge and center in alignment tab rename the sheet 1 worksheet with the new name "Sales" - Correct Answer โœ…1. right click on the worksheet
  6. click on rename
  7. type in new name "Sales"
  8. hit enter button enter the text "2020 Sales" in the bar chart title placeholder - Correct Answer โœ…1. click on chart title on bar chart

(Latest Update 2024)

  1. delete current title
  2. enter the text "2020" sales
  3. click any cell change the color of the income statement sheet tab to green (standard colors section, column 6) - Correct Answer โœ…1. right click on the income statement sheet tab
  4. click on tab color
  5. choose desired color apply chart style 5 to the chart - Correct Answer โœ…1. click on chart
  6. click on design tab
  7. choose desired chart style clear the contents of cell b7 - Correct Answer โœ…1. click on cell
  8. right click on cell
  9. click clear contents

(Latest Update 2024)

  1. click and drag right hand corner square (fill handle) to c and d Insert a 3-D Pie chart into the worksheet, based on range A4:B7. - Correct Answer โœ…1. highlight cell range
  2. click on insert tab
  3. choose 3-d pie chart Select non-adjacent cells C4, C6, and C11. - Correct Answer โœ…1. click on cell c
  4. hold control button while clicking c6 and c Move the Stacked Column chart to a chart sheet; accept the default chart sheet name. - Correct Answer โœ…1. click on chart
  5. right click on chart
  6. choose move chart
  7. click on new sheet
  8. click ok

(Latest Update 2024)

enter the number 2100 in cell B12 - Correct Answer โœ…1. click on cell b

  1. type in number 2100
  2. click on a different cell or hit enter Apply the Berlin theme to the current workbook. - Correct Answer โœ…1. click on page layout tab
  3. click on themes
  4. choose desired theme (berlin theme) Apply the Percentage number format, with no decimal places, to range B7:D7. - Correct Answer โœ…1. highlight cell range
  5. choose number
  6. click on percent sign Change the width of column C to exactly 15 characters. - Correct Answer โœ…1. right click on desired column
  7. choose column width
  8. type in desired column width size and hit ok

(Latest Update 2024)

and B11, and then multiplies that result by 12. - Correct Answer โœ…1. click on cell

  1. click on editing and autosum
  2. highlight cell range
  3. close parenthesis and multiply by 12
  4. hit enter In cell B16, create a formula using the AVERAGE function to calculate the average of the values in the range B4:B15. - Correct Answer โœ…1. click on cell
  5. click on editing and choose average
  6. highlight cell range
  7. hit enter In cell E16, create a formula using the MAX function to calculate the maximum value in the range E4:E14. - Correct Answer โœ…1. click on cell
  8. type in equal sign and MAX with open parenthesis
  9. highlight cell range
  10. close parenthesis and hit enter

(Latest Update 2024)

In cell E17, create a formula using the MIN function to calculate the minimum value in the range E4:E14. - Correct Answer โœ…1. click on cell

  1. type in equal sign and MIN with open parenthesis
  2. highlight range
  3. close parenthesis and hit enter In cell B16, create a formula using the SUM function to total the values in the range B4:B15. - Correct Answer โœ…1. click on cell
  4. click on editing and choose autosum
  5. highlight range
  6. hit enter For range B4:B15, create a New conditional formatting rule that formats the top five values in the range with a Green, Accent 6 cell background color (last color option in the top row of colors). - Correct Answer โœ…1. highlight cells
  7. click on conditional formatting

(Latest Update 2024)

Apply the 03/14/12 Date number format to cell D4. - Correct Answer โœ…1. click on cell

  1. right click and choose format cells
  2. choose correct format under date and hit ok change the height of row 2 to approximately 27 points ( pixels) - Correct Answer โœ…1. right click on row
  3. click on change row width
  4. type in desired width
  5. hit okay For values in the range B3:B12, adjust the number of decimal places so that two decimal places are displayed - Correct Answer โœ…1. highlight cell range
  6. right click and choose format cells
  7. move 2 decimal points change spelling in the entire worksheet, accepting the suggested correction - Correct Answer โœ…1. click review sheet

(Latest Update 2024)

  1. click spelling
  2. accept change Change the worksheet margins to the Narrow margin style. - Correct Answer โœ…1. click on page layout
  3. click on margins
  4. click on desired margin in cell b16, use the keyboard to enter a formula that uses the SUM function to calculate the total of the values in range B4:B15 - Correct Answer โœ…1. click on cell
  5. type in =SUM(
  6. highlight cell range Use Flash Fill to fill range E4:E15 after typing [email protected] in cell E4 and Lau in cell E5 - Correct Answer โœ…1. type in required information
  7. type in three letters and hit enter for flash fill

(Latest Update 2024)

enter a formula in cell d5 that divides the value in cell c5 by the value in cell c17, using an absolute cell reference to cell c17 - Correct Answer โœ…1. click cell

  1. type in cell divided by next cell
  2. hold fn button and do f4 button
  3. hit enter In cell F4, enter a formula using the IF function that returns a value of YES if cell E4 is greater than 0 (zero), and a value of NO if not. - Correct Answer โœ…1. click on cell
  4. click on small fx box
  5. choose select category
  6. choose logical and hit okay
  7. type E4>0 for logical test box
  8. type in yes for true, no for false, and hit ok! Rotate the contents of the cells in range B3:M3 to exactly 45 degrees. - Correct Answer โœ…1. highlight cells
  9. click on alignment and choose the small arrow in the corner

(Latest Update 2024)

  1. type in 45 for degrees add chart title chart element to pie chart - Correct Answer โœ…1. click on chart
  2. hit green plus sign
  3. click chart title Add the data labels chart element to the Bar chart at the Outside End position. - Correct Answer โœ…1. click on chart
  4. click on green plus size
  5. click data labels and choose outside end change text direction of vertical axis to horizontal - Correct Answer โœ…1. right click on vertical title and choose format
  6. choose alignment
  7. change text direction to horizontal split worksheet - Correct Answer โœ…1. click on cell
  8. click on view tab