CGS1060c Word project, excel project, powerpoint project

Edit document as instructed, will be given a list of instructions.

word project

In this project, you will modify a research paper. You will format text and format the document using themes. You will use the Replacecommand to correct errors in the document. You will add and format a table and insert a footnote. Adding citations is an important part of writing a research paper. You will add a citation using an existing source, add a new source, and create bibliography for the paper. Finally, you will check the research paper for spelling and grammar.

Skills needed to complete this project:

• Apply document themes
• Apply style sets
• Select text
• Use quick styles
• Use character formatting (underline and bold)
• Change fonts
• Change font sizes
• Change paragraph alignment
• Change line spacing
• Replace text
• Create a numbered list
• Create a bulleted list
• Creating a table
• Enter text

in a table

• Apply a Quick Style to a table
• Cut and paste a paragraph of text
• Add a header
• Insert page numbers
• Display a different header on the first page of the document
• Insert a footnote
• Add citations to a document
• Select a reference style
• Insert a page breaks
• Creating a bibliography
• Check for spelling errors
• Check for grammar errors

———–

——————————

excel project

In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will insert a new worksheet and enter sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and then set up the worksheet for printing. Next, you will help Top’t Corn decide whether or not a new truck loan is a good idea. Working with the daily sales data for one of the brick-and-mortar stores, you will calculate the sales for each date, and the average, minimum, and maximum sales. Finally, you will work with the online sales data to format it as an Excel table and apply sorting and filtering.

Skills needed to complete this project:

• Close a workbook
• Insert a worksheet
• Name a worksheet
• Move a worksheet

Enter text

• Enter numbers
• Edit text
• Autofit a column
• Apply a cell style
• Add cell shading
• Change font color
• Merge and center text across cells
• Apply bold formatting
• Apply number formatting
• Enter a SUM function
• Copy formula using AutoFill
• Insert a pie chart
• Apply a chart Quick Layout
• Move a chart
• Insert a column chart
• Switch the row/column in a column chart
• Change the chart title
• Apply a chart Quick Style
• Show chart data labels
• Preview how a worksheet will look when printed
• Change worksheet orientation
• Change the print margins
• Scale a worksheet for printing
• Change the color of a worksheet tab
• Apply a column width
• Enter a simple formula using multiplication
• Enter a simple formula using subtraction
• Add cell borders
• Create a formula referencing cells in another worksheet
• Enter an AVERAGE function
• Use the IF function
• Apply date formats
• Use an absolute reference in a formula
• Name a range of cells
• Use a named range in a formula
• Use the MIN function in a formula
• Use the MAX function in a formula
• Apply a table Quick Style
• Use the table Total row
• Sort data in a table
• Filter data in a table

———–

powerpoint project

In this project, you will modify a presentation for the Top’t Corn popcorn company. You will change the look of the entire presentation by applying a theme and theme variant. You will add content to the presentation including text (in Normal view and Outline view), a stock image, a table of information, and a chart. You will add a transition to all the slides in the presentation as well as animate objects on a slide. You will add information to the footer area of the slides as well as a note to a slide. Finally, you will practice running the presentation, and print handouts for your audience.

Skills needed to complete this project:

• Change the presentation theme
• Apply a theme variant
• Add text to slides
• Add a picture
• Add alt text to a picture
• Change the size of an image
• Move an image
• Enter text in Outline view
• Align text
• Add a numbered list
• Change the layout of a slide
• Create a table on a slide

Apply a Quick Style to a table

• Add a chart and enter the data
• Add a stock image
• Appy a picture Quick Style
• Apply and modify a slide transition
• Apply an animation effect
• Modify an animation
• Add the date to the footer
• Add custom text to the footer
• Add a note to a slide
• Start the slide show
• Navigate the slide show using the mouse and keyboard
• Print handouts